// 云函数入口文件
const cloud = require('wx-server-sdk')
const mysql = require('mysql2/promise')
cloud.init()

// 云函数入口函数
exports.main = async (event, context) => {
  const wxContext = cloud.getWXContext()
  var allID = event.allID;

  try {
    const connection = await mysql.createConnection({
      host: "47.115.22.254",
      port: 3306,
      database: "EPMS",
      user: "root",
      password: "1234"
    })

    var studentpro = 'SELECT * FROM provisional WHERE allID= "' + allID + '";';
    // var teacherpro = 'SELECT * FROM longpro WHERE allID= "' + allID + '";';

    var [studentrows, fields] = await connection.execute(studentpro);
    return studentrows
    

    conection.end();
  } catch (err) {
    return err
  }
}